MSSQLŸo(w¨²)·¨„h³ý¾S×o(h¨´)Ó‹(j¨¬)„-Ã¯ÃûÊÐÖÂ„Ù¾W(w¨£ng)½j(lu¨°)¹¤³ÌÓÐÏÞ¹«Ë¾

无码av在线一区二区三区_中文字字幕在线无线码_国产高清在线精品一区app_国产成人综合色在线观看网站

¼¼Ðg(sh¨´)²©¿ÍINFO

Â“(li¨¢n)ÏµÎÒ‚ƒCONTACT

¹«Ë¾µØÖ·£ºÃ¯ÃûÊÐÈËÃñÄÏÂ·ÐÂ´å´óÔº22Ì–(h¨¤o)101

ëŠÔ’£º13592986386

MSSQLŸo(w¨²)·¨„h³ý¾S×o(h¨´)Ó‹(j¨¬)„Äú®”(d¨¡ng)Ç°µÄÎ»ÖÃ£ºÊ×í“(y¨¨) > MSSQLŸo(w¨²)·¨„h³ý¾S×o(h¨´)Ó‹(j¨¬)„

MSSQLŸo(w¨²)·¨„h³ý¾S×o(h¨´)Ó‹(j¨¬)„

°l(f¨¡)²¼•r(sh¨ª)ég£º2020/2/8 17:25:42

use [msdb]

declare @job_name varchar(100)
set @job_name = N'5S.Subplan_1'
--×¢£ºjobNamežé¾S×o(h¨´)Ó‹(j¨¬)„Œ¦(du¨¬)‘ª(y¨©ng)µÄjobName
--„h³ýÔÚÓ‹(j¨¬)„ÀïÃæµÄÈÕÖ¾
delete sysmaintplan_log from sysmaintplan_subplans as subplans
inner join sysjobs_view as syjobs on subplans.job_id = syjobs.job_id
inner join sysmaintplan_log on subplans.subplan_id =sysmaintplan_log.subplan_id
where (syjobs.name = @job_name)
--„h³ý´úÀíµÄ×÷˜I(y¨¨)
delete sysjobschedules from sysjobs_view v
inner join sysjobschedules o on v.job_id=o.job_id where v.name=@job_name
--„h³ý×ÓÓ‹(j¨¬)„
delete sysmaintplan_subplans from sysmaintplan_subplans as subplans
inner join sysjobs_view as syjobs on subplans.job_id = syjobs.job_id
where (syjobs.name = @job_name)
--„h³ý×÷˜I(y¨¨)

无码av在线一区二区三区_中文字字幕在线无线码_国产高清在线精品一区app_国产成人综合色在线观看网站

ÖÂ„Ù¾W(w¨£ng)½j(lu¨°)

Ê×í“(y¨¨)

êP(gu¨¡n)ÓÚÖÂ„Ù

¾W(w¨£ng)Õ¾é_(k¨¡i)°l(f¨¡)

Ü›¼þ/Ð¡³ÌÐò°¸Àý

ÖÂ„ÙÜ›¼þ

·þ„Õ(w¨´)Æ÷×âÓÃ

ºÏ×÷¿Í‘ô

ÖÂ„Ùƒž(y¨u)„Ý(sh¨¬)

¼¼Ðg(sh¨´)²©¿Í

ÈË²ÅÕÐÆ¸

ÁôÑÔÐÅÏ¢

MSSQLŸo(w¨²)·¨„h³ý¾S×o(h¨´)Ó‹(j¨¬)„

MSSQLŸo(w¨²)·¨„h³ý¾S×o(h¨´)Ó‹(j¨¬)„

MSSQLŸo(w¨²)·¨„h³ý¾S×o(h¨´)Ó‹(j¨¬)„